﻿/*
 *  ChgDoc CMS - GNU General Public License, version 3 (GPL-3.0)
 *  Copyright (C)  2012. Ian Quigley
 *  
 *  This program is free software: you can redistribute it and/or modify
 *  it under the terms of the GNU General Public License as published by
 *  the Free Software Foundation, either version 3 of the License, or
 *  (at your option) any later version.
 *  
 *  This program is distributed in the hope that it will be useful,
 *  but WITHOUT ANY WARRANTY; without even the implied warranty of
 *  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 *  GNU General Public License for more details.
 */

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using SqliteORM;

namespace ChgDoc.Entity
{
    [Table]
    public class RolePermission : TableBase<RolePermission>
    {
        [ForeignKey(typeof(Role))]
        public long RoleId { get; set; }

        [ForeignKey( typeof( Permission ) )]
        public long PermissionId { get; set; }

        public static void AddRolePermission(long roleId, long permissionId)
        {
            Do(ad => ad.CreateUpdate(roleId, permissionId));
        }

        public static List<RolePermission> ReadAll()
        {
            return Get(ad => ad.Select().ToList());
        }

        public static List<RolePermission> ForRole(long roleId)
        {
            return Get(ad => ad.Select().Where(Where.Equal("RoleId", roleId)).ToList());
        }

        public static bool Exists(long roleId, long permissionId)
        {
            return Get(ad => ad.Select().Where(Where.And(Where.Equal("RoleId", roleId), Where.Equal("PermissionId", permissionId))).FirstOrDefault()) != null;
        }

        public static void Delete(long roleId, long permissionId)
        {
            Do(ad => ad.Delete(Where.And(Where.Equal("RoleId", roleId), Where.Equal("PermissionId", permissionId))));
        }

        public static void Create(long roleId, long permissionId)
        {
            Do(ad => ad.CreateUpdate(roleId, permissionId));
        }       
    }
}
